﻿
USE [Ext]
GO

DECLARE @tempTable TABLE
(
	[type]	TINYINT	NULL,
	[physical_name]	NVARCHAR(MAX)	NULL
)

INSERT INTO @tempTable
	SELECT f.[type], f.[physical_name]
	FROM [master].[sys].[master_files] AS f
	INNER JOIN [master]..[sysdatabases] AS db ON db.[dbid] = f.[database_id]
	--WHERE db.[name] = 'Ext'


